Mega Code Archive
String Functions
1) % is for any length of letters
2) ^ specifies the negation of a range or a list of characters
3) _ is for one letter
4) Any of the wildcard characters (%, _ [, ], or ) enclosed in square brackets stand for themselves
5) ASCII
6) ASCII(A)
7) Begin with a character in the range C through F
8) CHAR
9) CHAR(65)
10) CHAR(CAST(0x3A as int))
11) CHARINDEX
12) CHARINDEX()
13) CHARINDEX(Mars, The stars near Mars are far from ours)
14) COLLATE Latin1_General_CS_AS
15) Combine CHARINDEX with substring
16) Combine Lower() Upper() and substring() function to capital the first letter in a word
17) DATALENGTH()
18) DATALENGTH() for for Unicode character set
19) DATALENGTH(@Value)
20) DIFFERENCE
21) DIFFERENCE()
22) Get string to the right
23) LEFT
24) LEFT()
25) LEFT(Name,1)
26) LEN()
27) LEN(@Value)
28) Like with escape
29) LOWER
30) LTRIM
31) NCHAR
32) PATINDEX
33) PATINDEX(%M_rs%, The stars near Mars are far from ours)
34) QUOTENAME
35) REPLACE
36) REPLACE spaces
37) REPLACE()
38) REPLICATE
39) REPLICATE string
40) REPLICATE(, 20 - LEN(Name))
41) REVERSE
42) REVERSE()
43) RIGHT
44) RIGHT()
45) RIGHT(@RIGHT_STRING,10)
46) SELECT DIFFERENCE ( Fleas, Fleece)
47) SOUNDEX
48) SOUNDEX()
49) SPACE
50) SPACE(20 - LEN(Name))
51) Specifying an overall length greater than the length of the value, decimal point, and the decimal value, the result will
52) STR
53) STR() Function
54) STR() function right-fills the decimal value with zeros
55) STR(100 325,7)
56) STR(123 456789, 8, 4)
57) STUFF()
58) STUFF(string_used_as_basis, start_point, length, string_to_insert)
59) SUBSTRING()
60) SUBSTRING(string_to_remove_string_from, start_position, length)
61) Substring
62) UNICODE
63) UPPER
64) Use set to assign value to a variable with replicate function
65) Using the DIFFERENCE() function to compare Redmond with Renton